Views

Views (including updatable views) are implemented in MySQL Server 5.0 and available in binary releases from 5.0.1 and up. Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table). For access control to columns, you can also use the sophisticated privilege system in MySQL Server.

Just simply click to open an object pane for View. By using the object pane toolbar below, you can create new, edit, open and delete the selected view.

Create View

To create a new view

To create a new view with the same properties as one of the existing views has (using popup menu)

Apply to: current database {same connection}

To create a new view with the same properties as one of the existing views has (using drag and drop method)

Apply to: current database {same connection}
Apply to: different database {same connection}
  different database {different connection} (Data Transfer tool will be activated)
  • Select the view(s) for copying in the object pane.
  • Drag and drop the chosen view(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new view with modification as one of the existing views

To create a new view with loading from a SQL file

Edit View

To edit the existing view (manage its SQL definition etc)

To change the name of the view

Open View

To open a view (manage view data)

Delete View

To delete a view

View Shortcut

To create a view shortcut

Achieve View Information

To achieve a view information